DataDictionaryColumn

EntityType | Independent
Logical Entity Name | DataDictionaryColumn
Default Table Name | syDictionary
Logical Only | NO
Owner | dbo
Definition |
Note |

DataDictionaryColumn Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
Id |  | INTEGER | NO |
TableName |  | VARCHAR(255) | YES |
ColumnName |  | VARCHAR(255) | YES |
ColSeq |  | INTEGER | NO |
ColType |  | VARCHAR(20) | YES |
MaxLength |  | INTEGER | YES |
English |  | VARCHAR(255) | YES |
Spanish |  | VARCHAR(255) | YES |
Other |  | VARCHAR(255) | YES |
ApplicationRequired |  | BIT | NO |
UiRequired |  | BIT | NO |
UserUpdatable |  | BIT | NO |
ShowOnWeb |  | BIT | NO |
Security |  | BIT | NO |
EnglishToolTip |  | VARCHAR(255) | YES |
SpanishToolTip |  | VARCHAR(255) | YES |
OtherToolTip |  | VARCHAR(255) | YES |
Audit |  | BIT | NO |
Note |  | TEXT | YES |
Helpid |  | INTEGER | NO |
InputMask |  | VARCHAR(35) | YES |
SQLColType |  | VARCHAR(20) | YES |
SQLLength |  | INTEGER | YES |
SQLScale |  | TINYINT | YES |
SQLPrecision |  | INTEGER | YES |
SQLNulls |  | BIT | NO |
SQLDefault |  | VARCHAR(500) | YES |
DateAdded |  | DATETIME | YES |
UserID |  | INTEGER | NO |
DateLstMod |  | DATETIME | YES |
ts |  | TIMESTAMP/DATE | NO |
IsEnabledForCDC |  | BIT | NO |
SchemaName |  | NVARCHAR(255) | NO |

DataDictionaryColumn Keys

Key Name | Key Type | Keys
syDictionary_TableName_ColSeq_ColumnName_U_C_IDX | Alternate Key | TableName, ColumnName, ColSeq
syDictionary_syDictionaryID_U_N_IDX | Unique Constraint | Id
syDictionary_TableName_ColumnName_U_N_IDX | Unique Constraint | TableName, ColumnName, SchemaName
syDictionary_ts_N_N_IDX | Inversion Entry | ts
syDictionary_TableName_N_N_IDX | Inversion Entry | TableName
syDictionary_SyDictionaryID_U_C_IDX | PrimaryKey | Id

DataDictionaryColumn Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

DataDictionaryColumn Check Constraints

Check Constraint Name | CheckConstraint

DataDictionaryColumn Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.DataDictionaryColumn | NO |  |  |
Physical (Microsoft SQL Server) dbo.syDictionary | NO |  |  |

DataDictionaryColumn Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | System

DataDictionaryColumn Data Movement Rules

Name | Type | Rule Text/Value